5 <?xml version="1.0" encoding="UTF-8"?>
6 <manifest:manifest xmlns:manifest="urn:oasis:names:tc:opendocument:xmlns:manifest:1.0" manifest:version="1.2">
7 <manifest:file-entry manifest:full-path="/" manifest:version="1.2" manifest:media-type="application/vnd.oasis.opendocument.text"/>
8 <manifest:file-entry manifest:full-path="styles.xml" manifest:media-type="text/xml"/>
9 <manifest:file-entry manifest:full-path="content.xml" manifest:media-type="text/xml"/>
15 local iban="$2" bic="$3"
18 <?xml version="1.0" encoding="UTF-8"?>
19 <office:document-styles xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:officeooo="http://openoffice.org/2009/office" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2">
21 <style:style style:name="Standard" style:family="paragraph" style:class="text">
22 <style:paragraph-properties fo:text-align="start" style:justify-single-word="false"/>
23 <style:text-properties style:font-name="DejaVu Sans" fo:font-family="'DejaVu Sans'" style:font-family-generic="swiss" style:font-pitch="variable" style:font-size-asian="10.5pt" style:font-weight-asian="normal"/>
26 <office:automatic-styles>
27 <style:style style:name="MP1" style:family="paragraph">
28 <style:paragraph-properties fo:text-align="center" style:justify-single-word="false"/>
29 <style:text-properties style:font-name="DejaVu Sans" fo:font-size="10.5pt" style:font-size-asian="10.5pt" style:font-size-complex="10.5pt"/>
31 <style:style style:name="MT1" style:family="text">
32 <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
34 <style:page-layout style:name="Mpm1">
35 <style:page-layout-properties fo:page-width="8.2681in" fo:page-height="11.6929in" style:num-format="1" style:print-orientation="portrait" fo:margin-top="0.7874in" fo:margin-bottom="0.7874in" fo:margin-left="0.7874in" fo:margin-right="0.7874in" style:writing-mode="lr-tb" style:footnote-max-height="0in">
36 <style:footnote-sep style:width="0.0071in" style:distance-before-sep="0.0398in" style:distance-after-sep="0.0398in" style:line-style="solid" style:adjustment="left" style:rel-width="25%" style:color="#000000"/>
37 </style:page-layout-properties>
40 <style:header-footer-properties fo:min-height="0in" fo:margin-left="0in" fo:margin-right="0in" fo:margin-top="0.1965in"/>
43 </office:automatic-styles>
44 <office:master-styles>
45 <style:master-page style:name="Standard" style:page-layout-name="Mpm1">
47 <text:p text:style-name="MP1">
48 <text:span text:style-name="MT1">Bankverbindung - IBAN:</text:span>
49 <text:span>${iban} |</text:span>
50 <text:span text:style-name="MT1">BIC:</text:span>
51 <text:span>${bic}</text:span>
55 </office:master-styles>
56 </office:document-styles>
61 local id="$1" sender="$2" client="$3" date="$4" number="$5" vat="$6" vatrate="$7" hourly="$8"
64 <?xml version="1.0" encoding="UTF-8"?>
65 <office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:officeooo="http://openoffice.org/2009/office" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:drawooo="http://openoffice.org/2010/draw" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2">
66 <office:automatic-styles>
67 <style:style style:name="Table1" style:family="table">
68 <style:table-properties style:width="6.6931in" fo:margin-top="0in" fo:margin-bottom="0in" table:align="margins"/>
70 <style:style style:name="Table1.A" style:family="table-column">
71 <style:table-column-properties style:column-width="0.8903in" style:rel-column-width="8717*"/>
73 <style:style style:name="Table1.B" style:family="table-column">
74 <style:table-column-properties style:column-width="3.4028in" style:rel-column-width="33318*"/>
76 <style:style style:name="Table1.CD" style:family="table-column">
77 <style:table-column-properties style:column-width="1.2in" style:rel-column-width="11749*"/>
79 <style:style style:name="Table1.1" style:family="table-cell">
80 <style:table-cell-properties fo:padding="0.0201in" fo:border-left="none" fo:border-right="none" fo:border-top="none" fo:border-bottom="0.05pt solid #000000"/>
82 <style:style style:name="Table1.2" style:family="table-cell">
83 <style:table-cell-properties fo:padding="0.0201in" fo:border="none"/>
85 <style:style style:name="Table1.6" style:family="table-cell">
86 <style:table-cell-properties fo:padding="0.0201in" fo:border-left="none" fo:border-right="none" fo:border-top="0.05pt solid #000000" fo:border-bottom="none"/>
88 <style:style style:name="P3" style:family="paragraph" style:parent-style-name="Standard">
89 <style:text-properties style:font-name="DejaVu Sans" fo:font-size="10.5pt" style:font-size-asian="10.5pt" style:font-size-complex="10.5pt"/>
91 <style:style style:name="P5" style:family="paragraph" style:parent-style-name="Standard">
92 <style:paragraph-properties fo:text-align="end" style:justify-single-word="false"/>
93 <style:text-properties fo:font-size="10.5pt" style:font-size-asian="10.5pt" style:font-size-complex="10.5pt"/>
95 <style:style style:name="P6" style:family="paragraph" style:parent-style-name="Standard">
96 <style:paragraph-properties fo:text-align="start" style:justify-single-word="false"/>
97 <style:text-properties fo:font-weight="bold" fo:font-size="10.5pt" style:font-size-complex="10.5pt"/>
99 <style:style style:name="P7" style:family="paragraph" style:parent-style-name="Standard">
100 <style:paragraph-properties fo:text-align="end" style:justify-single-word="false"/>
101 <style:text-properties fo:font-weight="bold" fo:font-size="10.5pt" style:font-size-complex="10.5pt"/>
103 <style:style style:name="T3" style:family="text">
104 <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
106 <style:style style:name="fr1" style:family="graphic" style:parent-style-name="Standard">
107 <style:graphic-properties fo:margin-left="0in" fo:margin-right="0in" fo:margin-top="0in" fo:margin-bottom="0in" style:wrap="none" style:vertical-pos="from-top" style:vertical-rel="page-content" style:horizontal-pos="right" style:horizontal-rel="page-content" fo:padding="0in" fo:border="none" style:shadow="none" draw:shadow-opacity="100%"/>
109 <style:style style:name="fr2" style:family="graphic" style:parent-style-name="Standard">
110 <style:graphic-properties fo:margin-left="0in" fo:margin-right="0in" fo:margin-top="0in" fo:margin-bottom="0in" style:wrap="none" style:vertical-pos="top" style:vertical-rel="page-content" style:horizontal-pos="right" style:horizontal-rel="page-content" fo:padding="0in" fo:border="none" style:shadow="none" draw:shadow-opacity="100%"/>
112 <style:style style:name="fr3" style:family="graphic" style:parent-style-name="Standard">
113 <style:graphic-properties fo:margin-left="0in" fo:margin-right="0in" fo:margin-top="0in" fo:margin-bottom="0in" style:wrap="none" style:vertical-pos="from-top" style:vertical-rel="page-content" style:horizontal-pos="left" style:horizontal-rel="page-content" fo:padding="0in" fo:border="none" style:shadow="none" draw:shadow-opacity="100%"/>
115 </office:automatic-styles>
118 <text:p text:style-name="P3">
119 <draw:frame draw:style-name="fr1" draw:name="Rahmen4" text:anchor-type="paragraph" svg:y="2.7598in" svg:width="1.7283in">
120 <draw:text-box fo:min-height="0.2528in">
121 <text:p text:style-name="P5">$(date -d @${date} +%d.%m.%Y)</text:p>
123 </draw:frame><draw:frame draw:style-name="fr2" draw:name="Rahmen2" text:anchor-type="paragraph" svg:width="1.8228in">
124 <draw:text-box fo:min-height="1.8992in">
125 <text:p text:style-name="P5"><!--
126 -->$(HTML "$sender" |sed -r 's;(
\;)?
\;;<text:line-break/>;g')<!--
129 </draw:frame><draw:frame draw:style-name="fr3" draw:name="Rahmen1" text:anchor-type="paragraph" svg:y="1.3799in" svg:width="3.4398in">
130 <draw:text-box fo:min-height="1.3311in">
131 <text:p text:style-name="P3"><!--
132 -->$(HTML "$client" |sed -r 's;(
\;)?
\;;<text:line-break/>;g')<!--
135 </draw:frame><text:span text:style-name="T3">Rechnung ${issuance}</text:span>
137 <text:p text:style-name="P3"/>
138 <text:p text:style-name="P3"/>
139 <text:p text:style-name="P3">Vergütung: ${hourly} € / Std.<!--
142 printf '<text:line-break/>Gemäß Kleinunternehmerregelung (§19 Umsatzsteuergesetz) wird keine Umsatzsteuer berechnet.';;
143 (nett) printf 'zuzüglich %i%% MWSt.' "$vatrate";;
144 (gross) printf '(einschließlich %i\% MWSt.)' "$vatrate";;
147 <text:p text:style-name="P3"/>
148 <table:table table:name="Table1" table:style-name="Table1">
149 <table:table-column table:style-name="Table1.A"/>
150 <table:table-column table:style-name="Table1.B"/>
151 <table:table-column table:style-name="Table1.CD"/>
152 <table:table-column table:style-name="Table1.CD"/>
153 <table:table-header-rows>
155 <table:table-cell table:style-name="Table1.1" office:value-type="string">
156 <text:p text:style-name="P6">Datum</text:p>
158 <table:table-cell table:style-name="Table1.1" office:value-type="string">
159 <text:p text:style-name="P6">Art der Leistung</text:p>
161 <table:table-cell table:style-name="Table1.1" office:value-type="string">
162 <text:p text:style-name="P7">Stundenzahl</text:p>
164 <table:table-cell table:style-name="Table1.1" office:value-type="string">
165 <text:p text:style-name="P7">Betrag</text:p>
168 </table:table-header-rows>
169 $(sed 1d "invoices/$id" |while read -r time work hours; do
170 time="$(UNSTRING "${time#time=}")"
171 work="$(UNSTRING "${work#work=}")"
172 hours="$(UNSTRING "${hours#hours=}")"
175 <table:table-cell table:style-name="Table1.2" office:value-type="string">
176 <text:p text:style-name="P3">${time}</text:p>
178 <table:table-cell table:style-name="Table1.2" office:value-type="string">
179 <text:p text:style-name="P3">${item}</text:p>
181 <table:table-cell table:style-name="Table1.2" office:value-type="string">
182 <text:p text:style-name="P5">${hours}</text:p>
184 <table:table-cell table:style-name="Table1.2" office:value-type="string">
185 <text:p text:style-name="P5">$((${hourly} * ${hours})) €</text:p>
191 <table:table-cell table:style-name="Table1.6" office:value-type="string">
192 <text:p text:style-name="P6"/>
194 <table:table-cell table:style-name="Table1.6" office:value-type="string">
195 <text:p text:style-name="P6"/>
197 <table:table-cell table:style-name="Table1.6" office:value-type="string">
198 <text:p text:style-name="P7">Summe:</text:p>
200 <table:table-cell table:style-name="Table1.6" office:value-type="string">
201 <text:p text:style-name="P7">$(invoice_total "$id") €</text:p>
207 </office:document-content>
212 local id="$1" exdir="export/$1"
214 rm "$exdir/content.xml" "$exdir/styles.xml" "$exdir/META-INF/manifest.xml"
215 rmdir "$exdir/META-INF/" "$exdir/"
218 read -r sender client date number vat vatrate <<-EOF
219 $(sed q "invoices/$id")
221 read -r sender iban bic <"senders/${sender#sender=}"
222 read -r client hourly <"clients/${client#client=}"
224 mkdir -p "$exdir/META-INF"
225 odt_manifest >"$exdir/META-INF/manifest.xml"
226 odt_stylesheet "$(UNSTRING "${iban#iban=}")" "$(UNSTRING "${bic#bic=}")" >"$exdir/styles.xml"
228 "$(UNSTRING "${sender#address=}")" \
229 "$(UNSTRING "${client#address=}")" \
231 "$(UNSTRING "${number#number=}")" \
232 "${vat#vat=}" "${vatrate#vatrate=}" \
233 "${hourly#hourly=}" \
234 >"$exdir/content.xml"
236 [ -f "export/${id}.odt" ] && rm "export/${id}.odt"
238 zip -q "../${id}.odt" content.xml styles.xml META-INF/manifest.xml
240 rm "$exdir/content.xml" "$exdir/styles.xml" "$exdir/META-INF/manifest.xml"
241 rmdir "$exdir/META-INF/" "$exdir/"